marc carn vanished while drinking with friends in irish bar on las ramblas .
family grew concerned when he missed flight home to plymouth , devon .
he turned up at british consulate today after walking since saturday night .
29-year-old claims he was stranded by spanish driver miles outside the city .